﻿-- =============================================
-- Script Template
-- =============================================

if exists(select * from sysobjects where name='proc_userlookexpertNewshows')
drop proc proc_userlookexpertNewshows
go
create procedure proc_userlookexpertNewshows
@userId int,---用户ID
@expertId int---专家专题ID
as
declare @minId int;
set @minId=(select count(mid) from UserLookExpertNewsMsg  where userid=@userId and expertid=@expertId)
if(@minId>0)
 begin
 select Id, CreateTime, UserId, PlayId, PlayQiNo, Extitle, Keyword, Exmiaoshu, Uptime, Endtime, Scheme, ColourMoney, ClickSum, CheckMsg, ExperRemark from pm_expertNews where Id=@expertId
 end
 

